Previous Topic

Next Topic

Table Structures for EXPOCAD

These are the tables and fields involved in EXPOCAD:

Expo_Control

Stored in System_Params where ParameterName = Expo_Control. Additional fields have been added to the Expo_Control table. These fields will be used in the Expo System Setup window.

Column Name

Data Type/Size

Description

UseQtyOrSqrFt

Boolean

0 if using Quantity

1 if using Area (Square Units)

ImportRunning

Boolean

1 if import is running

ExpoCad_Prod

Stores the product mapping between EXPOCAD and iMIS.

Column Name

Data Type/Size

Description

MEET_ID

Char(10)

Event in EXPOCAD

Exposition code in iMIS

ExpoCad_Type

Char(40)

Booth Type in EXPOCAD

Island, Peninsula, Corner, Inline, Custom and Aisle Booth

Product_Code

Char(31)

Exposition 'Booth' product code

Premium_1

Char(31)

Exposition 'Other' or 'Paid Pass' product code

Qty_1

Numeric

Quantity for Premium_1

Premium_2

Char(31)

Exposition 'Other' or 'Paid Pass' product code

Qty_2

Numeric

Quantity for Premium_2

Meet_Master

Additional field has been added.

Column Name

Data Type/Size

Description

Meet_Category

Numeric

0 if iMIS exposition

1 if EXPOCAD exposition

Exhb_Booth

Additional field has been added.

Column Name

Data Type/Size

Description

Booth_Type

Char(40)

Stores the Booth Type from EXPOCAD

EXPOCAD: ExpoCadExp

A FoxPro database file created when an event in EXPOCAD is initially setup.

Column Name

Data Type/Size

Description

Count_Val

Numeric(18)

Value of the current counter. Equal to 0 when Proc_Desc ='iMISCounter'

UniqueID

Numeric(18)

Unique ID generated from the increment of Count_Val

Orig_Booth

Char(20)

Original Booth Number

New_Booth

Char(20)

New Booth Number

Booth_Size

Numeric(18)

Size of booth in square units

Booth_Type

Char(40)

Booth Type in EXPOCAD

Island, Peninsula, Corner, Inline, Custom and ab

Exhb_ID

Char(20)

Exhibitor ID

Event_Name

Char(20)

Event name in EXPOCAD

Exposition name in iMIS

Proc_Desc

Char(100)

Description of EXPOCAD activity

'Rent Booth','Unrent Booth','Booth Num Change','Booth Class Change', and 'iMISCounter'

Insert_Dat

Char(22)

Date record was added in EXPOCAD stored in CCYYMMDD HH:MM:SS format

Retrv_By

Char(100)

Upon successful import, stores the UserID+RetrieveDate, marking that line for deletion.

If the record fails the import, stores FAIL_UserID+RetrieveDate

See Also

Overview: EXPOCAD Interface

Introduction

EXPOCAD Interface Capabilities

EXPOCAD Components

Benefits of the EXPOCAD Interface

EXPOCAD Interface Terms

EXPOCAD Known Issue


ASI logo 10.6 Production Release. Updated 8/12/2005 2:37:39 PM
Copyright © by Advanced Solutions International, Inc. All rights reserved.